• Exploring New Card Visual in Power BI Desktop for Better Data Presentation

    Updated: 2023-10-31 05:00:00
    Learn about the new Card visual for Power BI and how this can be used and formatted for better presentation of data.

  • Change the default SQL Server locations for database data files, transaction log files and backup files

    Updated: 2023-10-31 05:00:00
    In this article, we look at how to change the default SQL Server locations for database data and log files and also for backup files.

  • SQL Convert Date to YYYYMMDD

    Updated: 2023-10-31 05:00:00
    Learn how to use the SQL CONVERT Date to yyyymmdd date format in SQL Server with numerous T-SQL examples.

  • SQL Server Loop through Table Rows without Cursor

    Updated: 2023-10-31 05:00:00
    Comparison of SQL loop through table row options with a SQL Server Cursor versus a While Loop.

  • Resolving could not open a connection to SQL Server errors

    Updated: 2023-10-31 05:00:00
    Solving - A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections and ERROR: (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server).

  • How to tell what SQL Server versions you are running

    Updated: 2023-10-31 05:00:00
    Check out this tip to easily find out what version of SQL Server you are running.

  • SQL Endpoints and Lakehouse UI Differences and Access Secrets

    Updated: 2023-10-30 17:00:57
    There are some differences and secrets between the UI of a SQL Endpoint and the UI of a Lakehouse. I believe the lakehouse UI was changed recently, otherwise you can blame me for being distracted to this level. Let’s analyze the differences and pending points between these UI’s. SQL Endpoints When using a SQL Endpoint, … The post SQL Endpoints and Lakehouse UI Differences and Access Secrets appeared first on Simple Talk.

  • Clumio - SQL Backups Built for DBAs, Loved by IT

    Updated: 2023-10-30 05:00:00
    Clumio's cloud-native SQL Server backups for AWS is the perfect backup solution for SQL Server on Amazon EC2 for successful cloud migrations, .NET applications in AWS, and running Windows workloads in tandem with AWS services.

  • Understanding Databricks Unity Catalog for Unified Data Governance

    Updated: 2023-10-27 05:00:00
    Organizations are beginning to switch to storage that provides unified data governance to company resources. Databricks Unity Catalog gives users a specific location to manage rights while offering granular access control and several other useful features.

  • How to use Machine Learning to make Predictions using Python and TensorFlow

    Updated: 2023-10-26 05:00:00
    This article looks at how to use machine learning to make predictions using Python code with the machine learning library TensorFlow.

  • Validate the contents of large dynamic SQL strings in SQL Server

    Updated: 2023-10-26 05:00:00
    Often when you are generating dynamic SQL you will want to validate the content of the query as opposed to just blindly executing it. Unfortunately, Management Studio can make it difficult to check that your command is complete, never mind to troubleshoot any errors that may occur when you do execute the command.

  • Database Projects for Microsoft Fabric Data Warehouse

    Updated: 2023-10-25 17:00:56
    Database Projects for Fabric Data Warehouse is one of the most recent news of Fabric for SDLC (Software Development Life Cycle). Microsoft released the Database Projects around 2010 and have they evolved since that year. The original name was a tool called SSDT, released as part of SQL Server, but running inside a Visual Studio … The post Database Projects for Microsoft Fabric Data Warehouse appeared first on Simple Talk.

  • Creating Applications with ChatGPT, LLMs and Generative AI - Overview

    Updated: 2023-10-25 05:00:00
    Learn about ChatGPT, LLMs, and Generative AI and how these technologies can be used for application development.

  • SQL NOT IN Operator

    Updated: 2023-10-25 05:00:00
    This tip will cover the SQL NOT IN operator and explain the functionality and use cases with several NOT IN examples.

  • SQL Server Cursor Example

    Updated: 2023-10-25 05:00:00
    A SQL Server cursor is a set of T-SQL logic to loop over a predetermined number of rows one at a time. The purpose for the cursor may be to update one row at a time or perform an administrative process such as SQL Server database backups in a sequential manner.

  • Create SSRS Reports to view the SQL Server Agent Job Details and Status

    Updated: 2023-10-24 05:00:00
    Learn how to build a SQL Server Reporting Services report to monitor SQL Server Agent jobs, the status, and the job details.

  • Exporting and Importing Data into SQL Server Using Files

    Updated: 2023-10-23 20:27:08
    There are plenty of applications and tools available that allow for the movement of data in and out of SQL Server. Some tools are built by Microsoft, such as SSIS or Azure Data Factory. Others are created by third parties, such as Databricks or Snowflake. Still other available options make use of SQL Server features … The post Exporting and Importing Data into SQL Server Using Files appeared first on Simple Talk.

  • Create Parameter Driven Databricks Engineering Notebooks

    Updated: 2023-10-23 05:00:00
    Learn how to use the Databricks utility library (dbutils) to read and write widgets which allows the data engineer to pass parameters to the notebook so that the same code (notebook) can be used to process multiple files.

  • Create a Notebook and Access Your Data in a Microsoft Fabric Lakehouse

    Updated: 2023-10-20 05:00:00
    This article will show how to create a notebook and access your data in a Microsoft Fabric Lakehouse.

  • DP-100 Designing and Implementing a Data Science Solution on Azure Exam Prep

    Updated: 2023-10-19 05:00:00
    Data Science is one of the best-paying jobs in the world. Microsoft now offers an official certification in Data Science and to help you get started, this article provides several links to help you get ready for the DP-100: Designing and Implementing a Data Science Solution on Azure exam.

  • Protecting your Cloud Assets

    Updated: 2023-10-18 19:20:36
    Organizations of all types and sizes are turning to the cloud for their application and data storage requirements. The cloud makes it possible for them to deploy their workloads more quickly and to scale them up and down as requirements change. Not only does this increase the organization’s flexibility, but it also frees up IT … The post Protecting your Cloud Assets appeared first on Simple Talk.

  • Improve Query Performance when SQL Server Ignores Nonclustered Index

    Updated: 2023-10-18 05:00:00
    In this article, we look at why SQL Server may not use a non-clustered index over the clustered index and what you can do to improve performance.

  • DROP TABLE IF EXISTS Examples for SQL Server

    Updated: 2023-10-18 05:00:00
    In this article we cover various ways to check if a SQL Server table exists before trying to drop the table to avoid the error Msg 3701 Level 11 State 5 cannot drop the table because it does not exist or you do not have permission.

  • Drop Table SQL Server Examples with T-SQL and SQL Server Management Studio

    Updated: 2023-10-18 05:00:00
    Learn drop table SQL Server examples with T-SQL and SQL Server Management Studio (SSMS).

  • SQL Date Format examples using SQL FORMAT Function

    Updated: 2023-10-18 05:00:00
    SQL Date Format examples using SQL FORMAT Function to format dates, time and numbers in SQL Server.

  • Low Code Data Analysis and Engineering with Bamboolib and Databricks AI Assistant

    Updated: 2023-10-17 05:00:00
    Learn about Databricks Assistant a context-aware native AI assistant and Bamboolib a no-code data analysis and transformation framework to enhance code quality and delivery time.

  • AWS Athena Partitioning to Improve Query Performance and Cost Reduction

    Updated: 2023-10-16 05:00:00
    In this article, we will look at how Amazon Athena can partition data based on data stored in AWS S3 to improve performance and reduce AWS costs.

  • SQL WHERE IN Filtering Examples for SELECT, UPDATE, and DELETE

    Updated: 2023-10-16 05:00:00
    Learn how to filter data using SQL WHERE IN for SQL SELECT, UPDATE, and DELETE queries with these several examples.

  • Don’t use DISTINCT as a “join-fixer”

    Updated: 2023-10-16 00:28:42
    I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a “join-fixer,” and I can explain what that means using an example. Let’s say we have the following grossly simplified schema, representing customers, products, and product categories: And then we have tables for orders … The post Don’t use DISTINCT as a “join-fixer” appeared first on Simple Talk.

  • SQL Server Security Primer

    Updated: 2023-10-15 20:00:56
    SQL Server security structure, mechanisms and methods are very thoroughly documented in the Microsoft documentation, but it is quite daunting if you don’t already know about the functionality. I recently had a request to explain some security features of SQL Server so that internal audits could be completed. While thinking about the request and preparing … The post SQL Server Security Primer appeared first on Simple Talk.

  • Understanding Locking, Data Modification and Committing Data in SQL Server

    Updated: 2023-10-13 05:00:00
    Learn about how SQL Server uses locks when modifying data and how data is committed to a database after data changes.

  • Use AI to Transcribe Audio from an MP3 or MP4 File and Store in SQL Server

    Updated: 2023-10-12 05:00:00
    In this article, we look at how to use AI to automatically transcribe the audio from an audio or video file and store the results in SQL Server.

  • Power Query Editor in Power BI for Formatting Text Columns

    Updated: 2023-10-11 05:00:00
    This article looks at ways to clean up text data used in Power BI reports and charts for a more meaningful and consistent message.

  • Compare Snowflake vs SQL Server GREATEST and LEAST Functions

    Updated: 2023-10-11 05:00:00
    In this article, we look at how to find the LEAST and GREATEST values in a set of numbers for Snowflake and SQL Server.

  • My Favorite T-SQL Enhancements in SQL Server 2022

    Updated: 2023-10-11 05:00:00
    A few of the most useful changes in SQL Server 2022 so far are GREATEST, LEAST, STRING_SPLIT, DATE_BUCKET and GENERATE_SERIES and I will cover each one and show practical use cases.

  • Reasons for SQL Server Query Performance Fluctuations

    Updated: 2023-10-10 05:00:00
    This article points out some reasons why a SQL Server query might be slower today than it was 10 minutes ago, two weeks ago, or last summer.

  • SQL Server Fragmentation Impact with Modern Hardware

    Updated: 2023-10-10 05:00:00
    Read this article to find out if you still need to worry about SQL Server index fragmentation with modern hardware.

  • Explore Natively Compiled SQL Server Stored Procedure Execution Plans

    Updated: 2023-10-09 05:00:00
    In this article, we look at execution plans and performance of a natively compiled stored procedure versus a traditional stored procedure.

  • Getting Started with Microsoft Power BI Training

    Updated: 2023-10-09 05:00:00
    Resources for learning and becoming more proficient with Power BI including articles, downloads, and courses.

  • SQL Server Data Masking with DbDefence

    Updated: 2023-10-07 05:00:00
    Data breaches are becoming too common place with some accounts reporting more than 1000 breaches per year with close to 50 million records exposed yearly in the financial, business, education, government and healthcare industries. Learn about how DbDefence performs SQL Server Data Masking as a portion of a three pronged approach to protect your data.

  • SQL Server Linked Server to Access Amazon Athena Tables

    Updated: 2023-10-06 05:00:00
    In this article, learn how to create a linked server from SQL Server to AWS Athena tables.

  • Oracle 23c Database New Features

    Updated: 2023-10-05 05:09:36
    Oracle 23c is the latest Release of Oracle Database. Oracle has introduced lot of new features in it. Here are the Top Features Developer-Friendly Features Oracle has been adding features to make developers’ lives easier, such as SQL and PL/SQL enhancements, JSON improvements, REST interfaces, etc. SELECT without FROM clause You can now run SELECT […] The post Oracle 23c Database New Features appeared first on Techgoeasy.

  • Natural Language AI Querying with Databricks English SDK

    Updated: 2023-10-05 05:00:00
    In this article, you'll learn how to ask complex questions in English and get the desired results within seconds using natural language AI querying with Databricks.

  • Configure Azure Databricks as a Delta Lakehouse

    Updated: 2023-10-05 05:00:00
    This article explains how to manually deploy, configure, and test the services needed to create a Delta Lakehouse design pattern for Azure Databricks.

  • What I Wish Everyone Knew About ETL Processes - Traditional to Modern Cloud Solutions

    Updated: 2023-10-04 05:00:00
    In this article, learn about the evolutionary journey of ETL (Extract, Transform, Load) from traditional processes to modern cloud solutions.

  • What are Lakehouses in Microsoft Fabric?

    Updated: 2023-10-04 05:00:00
    This guide will walk you through the process of creating a Data Lakehouse in Microsoft Fabric.

  • Connect to SQL Servers in another domain using Windows Authentication

    Updated: 2023-10-04 05:00:00
    You may find that you need to connect remotely to a SQL Server using Windows Authentication that is in another domain. In this tip, we walk through the steps on how this can be done.

Current Feed Items | Previous Months Items

Sep 2023 | Aug 2023 | Jul 2023 | Jun 2023 | May 2023 | Apr 2023